/*     */ package com.qmsk.business.member.member.dao;
/*     */ 
/*     */ import com.qmsk.business.sys.basic.SupportDAO;
/*     */ import com.utils.basic.MapUtils;
/*     */ import com.utils.gson.in.GsonHeadManyRows;
/*     */ import com.utils.gson.in.GsonHeadOneRow;
/*     */ import com.utils.gson.out.GsonEbRst;
/*     */ import java.sql.SQLException;
/*     */ import java.util.HashMap;
/*     */ import java.util.Map;
/*     */ 
/*     */ public class MemberDAO extends SupportDAO
/*     */ {
/*     */   public GsonEbRst getIntegralWeekRankList(Long shopId, Integer nPageIdx, Short nPageSize)
/*     */     throws SQLException
/*     */   {
/*  30 */     Map params = new HashMap();
/*  31 */     params.put("shopId", shopId);
/*  32 */     return getGsonOfParams("selectSqlOfIntegralWeekRank", params, 
/*  33 */       nPageIdx, nPageSize, true);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getIntegralRankList(Long shopId, Integer nPageIdx, Short nPageSize) throws SQLException
/*     */   {
/*  38 */     Map params = new HashMap();
/*  39 */     params.put("shopId", shopId);
/*  40 */     return getGsonOfParams("selectSqlOfIntegralRank", params, 
/*  41 */       nPageIdx, nPageSize, true);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getCustomerIntegralRank(Long shopId, String openId) throws SQLException
/*     */   {
/*  46 */     Map params = new HashMap();
/*  47 */     params.put("shopId", shopId);
/*  48 */     params.put("openId", openId);
/*  49 */     return getGsonOfParams("selectSqlOfCustomerIntegralRank", params, 
/*  50 */       true);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberId(Long memberId, Long shopId)
/*     */     throws SQLException
/*     */   {
/*  79 */     Map params = new HashMap();
/*  80 */     MapUtils.addToMap(params, "shopId", shopId);
/*  81 */     MapUtils.addToMap(params, "memberId", memberId);
/*  82 */     GsonEbRst g = getGsonOfParams("selectSqlOfCustId", 
/*  83 */       "selectCountSqlOfCustId", "selectJsonOfCustId", params, Integer.valueOf(0), 
/*  84 */       Short.valueOf((short) 1));
/*  85 */     setGbsonDecrypt(g);
/*  86 */     return g;
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfCustId(Long custId, Long shopId, Integer nPageIdx, Short nPageSize)
/*     */     throws SQLException
/*     */   {
/*  99 */     Map params = new HashMap();
/* 100 */     MapUtils.addToMap(params, "shopId", shopId);
/* 101 */     MapUtils.addToMap(params, "custId", custId);
/* 102 */     GsonEbRst g = getGsonOfParams("selectSqlOfCustId", 
/* 103 */       "selectCountSqlOfCustId", "selectJsonOfCustId", params, 
/* 104 */       nPageIdx, nPageSize);
/* 105 */     setGbsonDecrypt(g);
/* 106 */     return g;
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfCustIdBuss(Long custId, Integer nPageIdx, Short nPageSize)
/*     */     throws SQLException
/*     */   {
/* 119 */     Map params = new HashMap();
/* 120 */     params.put("custId", custId);
/* 121 */     return getGsonOfParams("selectSqlOfCustIdBuss", 
/* 122 */       "selectJsonOfCustIdBuss", params, nPageIdx, nPageSize);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfFindCustId(Long custId, Integer nPageIdx, Short nPageSize)
/*     */     throws SQLException
/*     */   {
/* 135 */     Map params = new HashMap();
/* 136 */     params.put("custId", custId);
/* 137 */     return getGsonOfParams("selectSqlFindCustId", "selectJsonOfCustIdBuss", 
/* 138 */       params, nPageIdx, nPageSize);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfFindCustId(Long custId) throws SQLException {
/* 142 */     Map params = new HashMap();
/* 143 */     params.put("custId", custId);
/* 144 */     return getGsonOfParams("selectSqlFindCustIdAttach", 
/* 145 */       "selectJsonOfCustIdAttach", params, Integer.valueOf(0), Short.valueOf((short) 1));
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfCardNoAttach(Map<String, Object> params) throws SQLException
/*     */   {
/* 150 */     return getGsonOfParams("selectSqlFindCustIdAttach", 
/* 151 */       "selectJsonOfCustIdAttach", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberIdAttach(Long memberId) throws SQLException {
/* 155 */     Map params = new HashMap();
/* 156 */     params.put("memberId", memberId);
/* 157 */     return getGsonOfParams("selectSqlFindCustIdAttach", 
/* 158 */       "selectJsonOfCustIdAttach", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfOutIdAttach(Long outId) throws SQLException {
/* 162 */     Map params = new HashMap();
/* 163 */     params.put("outId", outId);
/* 164 */     return getGsonOfParams("selectSqlFindCustIdAttach", 
/* 165 */       "selectJsonOfCustIdAttach", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberIdCustInfo(Long shopId, Long memberId, Long outId, String cardNo, Long groupId) throws SQLException
/*     */   {
/* 170 */     Map params = new HashMap();
/* 171 */     MapUtils.addToMap(params, "shopId", shopId);
/* 172 */     MapUtils.addToMap(params, "groupId", groupId);
/* 173 */     MapUtils.addToMap(params, "memberId", memberId);
/* 174 */     MapUtils.addToMap(params, "cardNo", cardNo);
/* 175 */     MapUtils.addToMap(params, "outId", outId);
/* 176 */     return getGsonOfParams("selectSqlOfCustInfo", params, false);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberIdCustInfo1(Long shopId, Long memberId, Long outId, String cardNo, Long groupId)
/*     */     throws SQLException
/*     */   {
/* 182 */     Map params = new HashMap();
/* 183 */     MapUtils.addToMap(params, "shopId", shopId);
/* 184 */     MapUtils.addToMap(params, "groupId", groupId);
/* 185 */     MapUtils.addToMap(params, "memberId", memberId);
/* 186 */     MapUtils.addToMap(params, "cardNo", cardNo);
/* 187 */     MapUtils.addToMap(params, "outId", outId);
/* 188 */     return getGsonOfParams("selectSqlOfCustInfo1", params, false);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfShopIdCustIdMini(Integer shopId, Long customerId)
/*     */     throws SQLException
/*     */   {
/* 199 */     Object[] params = { shopId, customerId };
/* 200 */     return getGsonOfParams("sql_ShopIdCustIdMini", "json_ShopIdCustIdMini", 
/* 201 */       params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfShopIdAndGroupId(Object groupId, Object shopId, Integer status, Integer nPageIdx, Short nPageSize)
/*     */     throws SQLException
/*     */   {
/* 214 */     Map params = new HashMap();
/* 215 */     params.put("groupId", groupId);
/* 216 */     params.put("shopId", shopId);
/* 217 */     params.put("status", status);
/* 218 */     GsonEbRst g = getGsonOfParams("selectSqlOfShopIdAndGroupId", 
/* 219 */       "selectSqlCountOfShopIdAndGroupId", "selectJsonOfCustId", 
/* 220 */       params, nPageIdx, nPageSize);
/* 221 */     setGbsonDecrypt(g);
/* 222 */     return g;
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberAndAll(Map<String, Object> params, Integer nPageIdx, Short nPageSize) throws SQLException
/*     */   {
/* 227 */     GsonEbRst g = getGsonOfParams("selectSqlOfShopIdAndGroupId", 
/* 228 */       "selectSqlCountOfShopIdAndGroupId", 
/* 229 */       "selectJsonOfShopIdAndGroupId", params, nPageIdx, nPageSize);
/* 230 */     setGbsonDecrypt(g);
/* 231 */     return g;
/*     */   }
/*     */ 
/*     */   public GsonHeadOneRow getOneRowOfMemberId(Long memberId) throws SQLException
/*     */   {
/* 236 */     Object[] params = { memberId };
/* 237 */     return getOneRowOfParams("select_sql_memberId", 
/* 238 */       "select_json_memberId", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getListOfShopIdOpt1(Map<String, ?> params, Integer nPageIdx, Short nPageSize) throws SQLException
/*     */   {
/* 243 */     GsonEbRst g = getGsonOfParams("selectSqlOfOpt1", 
/* 244 */       "selectCountSqlOfOpt1", "selectJsonOfOpt1", params, nPageIdx, 
/* 245 */       nPageSize);
/* 246 */     setGbsonDecrypt(g);
/* 247 */     return g;
/*     */   }
/*     */ 
/*     */   public GsonEbRst getListOfSumShopId(Map<String, ?> params) throws SQLException
/*     */   {
/* 252 */     return getGsonOfParams("selectSqlOfSumShopId", "selectJsonOfSumShopId", 
/* 253 */       params);
/*     */   }
/*     */ 
/*     */   public int updateDopositAmount(Map<String, ?> params) throws SQLException {
/* 257 */     return update("update_DopositAmount", params);
/*     */   }
/*     */ 
/*     */   public int update_DopositAmountInc(Map<String, ?> params) throws SQLException
/*     */   {
/* 262 */     return update("update_DopositAmountInc", params);
/*     */   }
/*     */ 
/*     */   public Double getDopositOfMemberId(Long memberId) throws SQLException {
/* 266 */     Object[] params = { memberId };
/* 267 */     return queryForDouble("selectSqlDopositOfMemberId", params, null);
/*     */   }
/*     */ 
/*     */   public int updateDopositAmountInc(Long memberId, Double amount) throws SQLException
/*     */   {
/* 272 */     int nResult = 0;
/* 273 */     Map params = new HashMap();
/*     */     try {
/* 275 */       params.put("memberId", memberId);
/* 276 */       params.put("amount", amount);
/* 277 */       nResult += update_DopositAmountInc(params);
/*     */     } finally {
/* 279 */       params.clear();
/* 280 */       params = null;
/*     */     }
/* 282 */     return nResult;
/*     */   }
/*     */ 
/*     */   public int updateMbBusBIllDeposit(Long memberId, Double amount) throws SQLException
/*     */   {
/* 287 */     int nResult = 0;
/* 288 */     Map params = new HashMap();
/*     */     try {
/* 290 */       params.put("memberId", memberId);
/* 291 */       params.put("amount", amount);
/* 292 */       nResult += updateDopositAmount(params);
/*     */     } finally {
/* 294 */       params.clear();
/* 295 */       params = null;
/*     */     }
/* 297 */     return nResult;
/*     */   }
/*     */ 
/*     */   public int updateMemberDeposit(GsonHeadManyRows g)
/*     */     throws SQLException
/*     */   {
/* 306 */     int nResult = 0;
/* 307 */     for (int i = 0; i < g.getDataLength(); ++i) {
/* 308 */       Map params = new HashMap();
/*     */       try {
/* 310 */         params.put("memberId", g.getValueOfName("memberId", i));
/* 311 */         params.put("amount", g.getValueOfName("amount", i));
/* 312 */         nResult += updateDopositAmount(params);
/*     */       } finally {
/* 314 */         params.clear();
/* 315 */         params = null;
/*     */       }
/*     */     }
/* 318 */     return nResult;
/*     */   }
/*     */ 
/*     */   public int updateBillMemberIntAmt(Long memberId, Integer intAmt) throws SQLException
/*     */   {
/* 323 */     int nResult = 0;
/* 324 */     Map params = new HashMap();
/*     */     try {
/* 326 */       params.put("memberId", memberId);
/* 327 */       params.put("intAmt", intAmt);
/* 328 */       nResult += updateBissBillAmountInc(params);
/*     */     } finally {
/* 330 */       params.clear();
/* 331 */       params = null;
/*     */     }
/* 333 */     return nResult;
/*     */   }
/*     */ 
/*     */   public int updateBissBillCashConp(Long memberId, Double cashCoup) throws SQLException
/*     */   {
/* 338 */     int nResult = 0;
/* 339 */     Map params = new HashMap();
/*     */     try {
/* 341 */       params.put("memberId", memberId);
/* 342 */       params.put("cashCoup", cashCoup);
/* 343 */       nResult += updateBissBillCashConpAmt(params);
/*     */     } finally {
/* 345 */       params.clear();
/* 346 */       params = null;
/*     */     }
/* 348 */     return nResult;
/*     */   }
/*     */ 
/*     */   public int updateMemberCashCoup(Double sum, Long memberID) throws SQLException
/*     */   {
/* 353 */     Object[] params = { sum, memberID };
/* 354 */     return update("updateMemberCashCoup", params);
/*     */   }
/*     */ 
/*     */   public int updateMemberIntAmt(Integer sum, Long memberID) throws SQLException
/*     */   {
/* 359 */     Object[] params = { sum, memberID };
/* 360 */     return update("updateMemberIt", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getIntDepositOfMemberId(Long memberId) throws SQLException {
/* 364 */     Object[] params = { memberId };
/* 365 */     return getGsonOfParams("selectSqlIntDepositOfMemberId", 
/* 366 */       "selectJsonIntDepositOfMemberId", params);
/*     */   }
/*     */ 
/*     */   public int queryPayPwd(Long memberId, String pwd) throws SQLException {
/* 370 */     Object[] params = { memberId, pwd };
/* 371 */     return queryForInt("queryPayPwd", params, Integer.valueOf(0)).intValue();
/*     */   }
/*     */ 
/*     */   public int updateMemberInc(Long memberId, Double dActual)
/*     */     throws SQLException
/*     */   {
/* 377 */     Object[] params = { dActual, memberId };
/* 378 */     return update("updateMemberInc", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getMberAmtofInt(Map<String, ?> params) throws SQLException
/*     */   {
/* 383 */     return getGsonOneOfParams("selectSqlMberAmtofInt", 
/* 384 */       "selectJsonMberAmtofInt", params);
/*     */   }
/*     */ 
/*     */   public Integer getVdayOfmemberId(Long memberId) throws SQLException {
/* 388 */     Object[] params = { memberId };
/* 389 */     return queryForInt("selectSqlVdayOfmemberId", params, Integer.valueOf(0));
/*     */   }
/*     */ 
/*     */   public int updateBissBillAmountInc(Map<String, ?> params) throws SQLException
/*     */   {
/* 394 */     return update("update_IntegralAmount", params);
/*     */   }
/*     */ 
/*     */   public int updateBissBillCashConpAmt(Map<String, ?> params) throws SQLException
/*     */   {
/* 399 */     return update("updateMemberCashConpAmt", params);
/*     */   }
/*     */ 
/*     */   public int updateAddMemberNum(Object memberId, Integer num) throws SQLException
/*     */   {
/* 404 */     Map params = new HashMap();
/* 405 */     params.put("memberId", memberId);
/* 406 */     params.put("num", num);
/* 407 */     return update("updateAddMemberNum", params);
/*     */   }
/*     */ 
/*     */   public int updateRdtionMemberNum(Object memberId, Integer washNums) throws SQLException
/*     */   {
/* 412 */     Map params = new HashMap();
/* 413 */     params.put("memberId", memberId);
/* 414 */     params.put("washNums", washNums);
/* 415 */     return update("updateRdtionMemberNum", params);
/*     */   }
/*     */ 
/*     */   public int getSvsNum(Long memberId) throws SQLException {
/* 419 */     Object[] params = { memberId };
/* 420 */     return queryForInt("selectSqlSvsNum", params, Integer.valueOf(0)).intValue();
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberIdBuss(Long memberId) throws SQLException {
/* 424 */     Map params = new HashMap();
/* 425 */     params.put("memberId", memberId);
/* 426 */     return getGsonOfParams("selectSqlOfMemberIdBuss", 
/* 427 */       "selectJsonOfMemberIdBuss", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfCardNoBuss(Object cardNo) throws SQLException {
/* 431 */     Map params = new HashMap();
/* 432 */     params.put("cardNo", cardNo);
/* 433 */     return getGsonOfParams("selectSqlOfMemberIdBuss", 
/* 434 */       "selectJsonOfMemberIdBuss", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonMemberOutId(Object outId) throws SQLException {
/* 438 */     Map params = new HashMap();
/* 439 */     params.put("outId", outId);
/* 440 */     return getGsonOfParams("selectSqlOfMemberIdBuss", 
/* 441 */       "selectJsonOfMemberIdBuss", params);
/*     */   }
/*     */ 
/*     */   public int updateMemberStatusNormal(Long memberId, String memberCardNO) throws SQLException
/*     */   {
/* 446 */     if (memberCardNO != null) {
/* 447 */       Object[] params = new Object[] { memberCardNO, memberId };
/* 448 */       return update("updateMemberStatusNormall", params);
/*     */     }
/* 450 */     Object[] params = { memberId };
/* 451 */     return update("updateMemberStatusNormal", params);
/*     */   }
/*     */ 
/*     */   public int getCardNoIsExsit(Object memberCardNo, Object shopId)
/*     */     throws SQLException
/*     */   {
/* 457 */     Object[] params = { shopId, memberCardNo };
/* 458 */     return queryForInt("selectCardNoIsExsit", params, Integer.valueOf(0)).intValue();
/*     */   }
/*     */ 
/*     */   public int updateCardNo(Object memberId, Object memberCardNo) throws SQLException
/*     */   {
/* 463 */     Object[] params = { memberCardNo, memberId };
/* 464 */     return update("updateCardNo", params);
/*     */   }
/*     */ 
/*     */   public GsonHeadOneRow getPaidOneRowOfMemberId(Object memberId) throws SQLException
/*     */   {
/* 469 */     Object[] params = { memberId };
/* 470 */     return getOneRowOfParams("selectSqlOneRowOfMemberId", 
/* 471 */       "selectJsonOneRowOfMemberId", params);
/*     */   }
/*     */ 
/*     */   public Integer getOldMemberStatus(Object id) throws SQLException {
/* 475 */     Object[] params = { id };
/* 476 */     return queryForInt("selectSqlMemberOldStatus", params, Integer.valueOf(0));
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfCustIdMini(Long custId) throws SQLException {
/* 480 */     Object[] params = { custId };
/* 481 */     return getGsonOfParams("selectSqlOfCustIdMini", 
/* 482 */       "selectJsonOfCustIdMini", params);
/*     */   }
/*     */ 
/*     */   public int getIsMoneyToNull(Long id) throws SQLException {
/* 486 */     Object[] params = { id };
/* 487 */     return queryForInt("selectMoneyToNull", params, Integer.valueOf(0)).intValue();
/*     */   }
/*     */ 
/*     */   public void setGbsonDecrypt(GsonEbRst g) {
/* 491 */     g.decryIdxAES("PayPwd");
/*     */   }
/*     */ 
/*     */   public int updateRefDeposit(Long memberId, Double dposit) throws SQLException
/*     */   {
/* 496 */     Object[] params = { dposit, memberId };
/* 497 */     return update("updateRefDeposit", params);
/*     */   }
/*     */ 
/*     */   public int updateMemberCash(Long memberId, Double dCach) throws SQLException
/*     */   {
/* 502 */     Object[] params = { dCach, memberId };
/* 503 */     return update("updateMemberCash", params);
/*     */   }
/*     */ 
/*     */   public String getserviceMan(Long id) throws SQLException {
/* 507 */     Object[] params = { id };
/* 508 */     return queryForString("selectSqlServiceMan", params, null);
/*     */   }
/*     */ 
/*     */   public Integer getLevelIdNormal(Object memberId, Integer stId)
/*     */     throws SQLException
/*     */   {
/* 518 */     Map params = new HashMap();
/* 519 */     params.put("memberId", memberId);
/* 520 */     if (stId.intValue() == 1) {
/* 521 */       int[] status = { 1, 
/* 522 */         2, 3, 
/* 523 */         4, 5, 
/* 524 */         6 };
/* 525 */       params.put("status", status);
/*     */     } else {
/* 527 */       params.put("status", Integer.valueOf(2));
/*     */     }
/* 529 */     return queryForInt("selectSqlNormalLevelID", params, Integer.valueOf(0));
/*     */   }
/*     */ 
/*     */   public int getaddWashCarRst(Object memberId) throws SQLException {
/* 533 */     Object[] params = { memberId };
/* 534 */     return update("", params);
/*     */   }
/*     */ 
/*     */   public Long getLevelId(Long id) throws SQLException {
/* 538 */     Object[] params = { id };
/* 539 */     return queryForLong("selectSqlLevelID", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public Long getGsonOfCardNo(String cardNo) throws SQLException {
/* 543 */     Object[] params = { cardNo };
/* 544 */     return queryForLong("selectSqlGetID", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public int updateCardNoOfId(String cardNo, Long outMId, Long id) throws SQLException
/*     */   {
/* 549 */     Map params = new HashMap();
/* 550 */     params.put("cardNo", cardNo);
/* 551 */     params.put("id", id);
/* 552 */     params.put("outMId", outMId);
/* 553 */     return update("updateCardNoOfId", params);
/*     */   }
/*     */ 
/*     */   public Long getOutMIdOfId(Long id) throws SQLException {
/* 557 */     Map params = new HashMap();
/* 558 */     params.put("id", id);
/* 559 */     return queryForLong("getOutMIdOfId", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public int updateStatusOfId(Integer status, Long id) throws SQLException {
/* 563 */     Map params = new HashMap();
/* 564 */     MapUtils.addToMap(params, "status", status);
/* 565 */     MapUtils.addToMap(params, "id", id);
/* 566 */     return update("updateStatusOfId", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberOfVCard(Map<String, Object> params) throws SQLException
/*     */   {
/* 571 */     return getGsonOfParams("selectSqlMemberOfViceCard", params, false);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getCustNameOfShopId(Map<String, ?> params, Integer nPageIdx, Short nPageSize) throws SQLException
/*     */   {
/* 576 */     return getGsonOfParams("getSqlCustNameOfShopId", params, nPageIdx, 
/* 577 */       nPageSize, true);
/*     */   }
/*     */ 
/*     */   public int updateCleanMp(Long id) throws SQLException {
/* 581 */     Object[] params = { id };
/* 582 */     return update("updateCleanMp", params);
/*     */   }
/*     */ 
/*     */   public String getMaxMemberNo() throws SQLException {
/* 586 */     return super.getSpTableFieldMaxString("CardNo");
/*     */   }
/*     */ 
/*     */   public Long selectMemberIdOfCustId(Long id) throws SQLException {
/* 590 */     Object[] params = { id };
/* 591 */     return queryForLong("selectMemberIdOfCustId", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public String selectCardNoOfCustId(Long id) throws SQLException {
/* 595 */     Object[] params = { id };
/* 596 */     return queryForString("selectCardNoOfCustId", params, null);
/*     */   }
/*     */ 
/*     */   public int updateDopositCashCoupInc(Map<String, Object> params) throws SQLException
/*     */   {
/* 601 */     return update("updateDopositCashCoupInc", params);
/*     */   }
/*     */ 
/*     */   public int updateIntrCashCoupSub(Map<String, Object> params) throws SQLException
/*     */   {
/* 606 */     return update("updateIntrCashCoupSub", params);
/*     */   }
/*     */ 
/*     */   public Long getIsMember(String mp, Long shopId) throws SQLException {
/* 610 */     Map params = new HashMap();
/* 611 */     params.put("status", Integer.valueOf(2));
/* 612 */     params.put("mp", mp);
/* 613 */     params.put("shopId", shopId);
/* 614 */     return queryForLong("selectSqlIsMember", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public Long getIsMemberRg(String mp, Long shopId) throws SQLException {
/* 618 */     Map params = new HashMap();
/* 619 */     params.put("mp", mp);
/* 620 */     params.put("shopId", shopId);
/* 621 */     return queryForLong("selectSqlIsMember", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public GsonEbRst getWxMemberInfo(String openId, Long shopId) throws SQLException
/*     */   {
/* 626 */     Object[] params = { openId, shopId };
/* 627 */     return getGsonOfParams("selectSqlWxMemberInfo", params, false);
/*     */   }
/*     */ 
/*     */   public Long getMemberIdOfOpenId(String openId, Long shopId) throws SQLException
/*     */   {
/* 632 */     Object[] params = { openId, shopId };
/* 633 */     return queryForLong("selectSqlMemberIdOfOpenId", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public String getCustMp(Long memberId) throws SQLException {
/* 637 */     Object[] params = { memberId };
/* 638 */     return queryForString("getCustMp", params, null);
/*     */   }
/*     */ 
/*     */   public String getOpenId(Long memberId) throws SQLException {
/* 642 */     Object[] params = { memberId };
/* 643 */     return queryForString("getOpenId", params, null);
/*     */   }
/*     */ 
/*     */   public Long getIsMemberRgNew(String mp, String openId, Long shopId) throws SQLException
/*     */   {
/* 648 */     Map params = new HashMap();
/* 649 */     params.put("mp", mp);
/* 650 */     params.put("shopId", shopId);
/* 651 */     params.put("openId", openId);
/* 652 */     return queryForLong("selectSqlIsMember", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public Long getIsMemberRgNew(String openId, Long shopId)
/*     */     throws SQLException
/*     */   {
/* 658 */     Map params = new HashMap();
/* 659 */     params.put("shopId", shopId);
/* 660 */     params.put("openId", openId);
/* 661 */     return queryForLong("selectSqlIsWxMember", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public GsonHeadOneRow getIsMemberRgOfOneRow(String openId, Long shopId) throws SQLException
/*     */   {
/* 666 */     Map params = new HashMap();
/* 667 */     params.put("shopId", shopId);
/* 668 */     params.put("openId", openId);
/* 669 */     return getOneRowOfParams("getIsMemberRgOfOneRow", params);
/*     */   }
/*     */ 
/*     */   public Long getMemberId(Long custId) throws SQLException {
/* 673 */     Object[] params = { custId };
/* 674 */     return queryForLong("getMemberId", params, Long.valueOf(0L));
/*     */   }
/*     */ }

/* Location:           C:\Users\Administrator\Desktop\新建文件夹\WEB-INF\classes\
 * Qualified Name:     com.qmsk.business.member.member.dao.MemberDAO
 * JD-Core Version:    0.5.3
 */